#!/usr/bin/python
# -*- coding: utf-8 -*-  

"""
@Project : hello 
@file : cdc_commons.py
@Author : sheen
@time : 2025/4/10 10:52
@func : cdc生产连接信息汇总

"""

bu_list = ['kvn', 'kvb', 'wtctr', 'drlv', 'drlt', 'tps', 'icinl', 'icibe']

db_database=['asw_etl_icinl_job']

mysql_pro_connections = {
    'kvb_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'kvb_pro_cal':{'host': '10.128.56.153', 'port': 33448, 'user': 'cdcapp_kvb', 'password': 'y^Ttl89m21pC94y2'},
    'kvb_pro_member':{'host': '10.128.56.153', 'port': 36008, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    # 'kvb_pro_proxy':{'host': '10.128.56.153', 'port': 31410, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'kvb_pro_proxy':{'host': '10.128.56.153', 'port': 31410, 'user': 'cdcjob_kvb', 'password': 'p438jUPYgI8SVD^t'},


    'kvn_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'kvn_pro_cal0_32':{'host': '10.128.56.153', 'port': 35272, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal33_36':{'host': '10.128.56.153', 'port': 38919, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal67_100':{'host': '10.128.56.153', 'port': 39944, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal101_127':{'host': '10.128.56.153', 'port': 33409, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_member':{'host': '10.128.56.153', 'port': 36534, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    # 'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 33726, 'user': 'cdcapp_kvn', 'password': 'p438jUPYgI8SVD^t'},
    # 'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 33726, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 38017, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},


    'tps_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'tps_pro_cal':{'host': '10.128.56.153', 'port': 32257, 'user': 'cdcapp_tps', 'password': 'y^Ttl89m21pC94y2'},
    'tps_pro_member':{'host': '10.128.56.153', 'port': 39798, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'tps_pro_proxy':{'host': '10.128.56.153', 'port': 32244, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},


    'wtctr_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal0_32':{'host': '10.128.56.153', 'port': 32331, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal33_36':{'host': '10.128.56.153', 'port': 34241, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal67_100':{'host': '10.128.56.153', 'port': 30423, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal101_127':{'host': '10.128.56.153', 'port': 30037, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_member':{'host': '10.128.56.153', 'port': 37860, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_proxy':{'host': '10.128.56.153', 'port': 34703, 'user': 'cdcapp_wtctr', 'password': 'p438jUPYgI8SVD^t'},


    'drlt_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_drlt', 'password': 'p438jUPYgI8SVD^t'},
    'drlt_pro_cal':{'host': '10.128.56.153', 'port': 33400, 'user': 'cdcapp_drlt', 'password': 'jzZ2TOh^jGeNjEBj'},
    'drlt_pro_member':{'host': '10.128.56.153', 'port': 34368, 'user': 'cdcapp_drlt', 'password': 'jzZ2TOh^jGeNjEBj'},
    'drlt_pro_proxy':{'host': '10.128.56.153', 'port': 34110, 'user': 'cdcapp_drlt', 'password': 'p438jUPYgI8SVD^t'},


    'drlv_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_cal':{'host': '10.128.56.153', 'port': 32728, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_member':{'host': '10.128.56.153', 'port': 32195, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_proxy':{'host': '10.128.56.153', 'port': 39320, 'user': 'cdcapp_drlv', 'password': 'p438jUPYgI8SVD^t'},


    'icinl_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_cal':{'host': '10.128.56.153', 'port': 37993, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_member':{'host': '10.128.56.153', 'port': 39644, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_proxy':{'host': '10.128.56.153', 'port': 34419, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},


    'icibe_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_icibe', 'password': 'xMm$jRPY$L2CJ0N5'},
    'icibe_pro_cal':{'host': '10.128.56.153', 'port': 38720, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'icibe_pro_member':{'host': '10.128.56.153', 'port': 38639, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'icibe_pro_proxy':{'host': '10.128.56.153', 'port': 39026, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},


    'tp_pro_write':{'host': '10.128.56.90', 'user': 'cdcapp_tp', 'port': 3310, 'password': 'D)$V0%4Dr0a&'},
    'tp_pro_support':{'host': '10.128.56.153', 'user': 'cdcapp_tp', 'port': 34276, 'password': 'D)$V0%4Dr0a&'}

}
oracle_adm_connections={
    'drlt_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'drlv_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvb_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvn_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},

    'tps_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},
    'wtctr_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},

    'icibe_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'icibe_pro_dict': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'host': 'exa4-scan.uk.aswatson.net', 'port': 1521, 'service_name': 'CRMBKVP'},
    'icinl_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'}

}
oracle_siebel_connections={
    'icibe_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'},
    'siebel_icibe_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'}

}
siebel_pro_cons={
    'icibe_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'},
    'icinl_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'}
}
cdc_pro_cons = {
    'kvb_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'kvb_pro_cal':{'host': '10.128.56.153', 'port': 33448, 'user': 'cdcapp_kvb', 'password': 'y^Ttl89m21pC94y2'},
    'kvb_pro_member':{'host': '10.128.56.153', 'port': 36008, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    # 'kvb_pro_proxy':{'host': '10.128.56.153', 'port': 31410, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'kvb_pro_proxy':{'host': '10.128.56.153', 'port': 31410, 'user': 'cdcjob_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_kvb_job_ro': {'host': '10.128.56.153', 'port': 31410, 'user': 'cdcjob_kvb', 'password': 'p438jUPYgI8SVD^t'},

    'kvn_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'kvn_pro_cal0_32':{'host': '10.128.56.153', 'port': 35272, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal33_36':{'host': '10.128.56.153', 'port': 38919, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal67_100':{'host': '10.128.56.153', 'port': 39944, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal101_127':{'host': '10.128.56.153', 'port': 33409, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_member':{'host': '10.128.56.153', 'port': 36534, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    # 'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 33726, 'user': 'cdcapp_kvn', 'password': 'p438jUPYgI8SVD^t'},
    # 'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 33726, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 38017, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_kvn_job_ro': {'host': '10.128.56.153', 'port': 33726, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},

    'tps_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'tps_pro_cal':{'host': '10.128.56.153', 'port': 32257, 'user': 'cdcapp_tps', 'password': 'y^Ttl89m21pC94y2'},
    'tps_pro_member':{'host': '10.128.56.153', 'port': 39798, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'tps_pro_proxy':{'host': '10.128.56.153', 'port': 32244, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_tps_job_ro': {'host': '10.128.56.153', 'port': 32244, 'user': 'cdcjob_tps', 'password': 'p438jUPYgI8SVD^t'},

    'wtctr_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal0_32':{'host': '10.128.56.153', 'port': 32331, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal33_36':{'host': '10.128.56.153', 'port': 34241, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal67_100':{'host': '10.128.56.153', 'port': 30423, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal101_127':{'host': '10.128.56.153', 'port': 30037, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_member':{'host': '10.128.56.153', 'port': 37860, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_proxy':{'host': '10.128.56.153', 'port': 34703, 'user': 'cdcapp_wtctr', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_wtctr_job_ro': {'host': '10.128.56.153', 'port': 34703, 'user': 'cdcjob_wtctr','password': 'p438jUPYgI8SVD^t'},

    'drlt_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_drlt', 'password': 'p438jUPYgI8SVD^t'},
    'drlt_pro_cal':{'host': '10.128.56.153', 'port': 33400, 'user': 'cdcapp_drlt', 'password': 'jzZ2TOh^jGeNjEBj'},
    'drlt_pro_member':{'host': '10.128.56.153', 'port': 34368, 'user': 'cdcapp_drlt', 'password': 'jzZ2TOh^jGeNjEBj'},
    'drlt_pro_proxy':{'host': '10.128.56.153', 'port': 34110, 'user': 'cdcapp_drlt', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_drlt_job_ro': {'host': '10.128.56.153', 'port': 34110, 'user': 'cdcjob_drlt', 'password': 'p438jUPYgI8SVD^t'},

    'drlv_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_cal':{'host': '10.128.56.153', 'port': 32728, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_member':{'host': '10.128.56.153', 'port': 32195, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_proxy':{'host': '10.128.56.153', 'port': 39320, 'user': 'cdcapp_drlv', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_drlv_job_ro': {'host': '10.128.56.153', 'port': 39320, 'user': 'cdcjob_drlv', 'password': 'p438jUPYgI8SVD^t'},

    'icinl_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_cal':{'host': '10.128.56.153', 'port': 37993, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_member':{'host': '10.128.56.153', 'port': 39644, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_proxy':{'host': '10.128.56.153', 'port': 34419, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'cdc_icinl_job_ro': {'host': '10.128.56.153', 'port': 34419, 'user': 'cdcjob_icinl','password': 'bg*m9cPJF37oMRus'},

    'icibe_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_icibe', 'password': 'xMm$jRPY$L2CJ0N5'},
    'icibe_pro_cal':{'host': '10.128.56.153', 'port': 38720, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'icibe_pro_member':{'host': '10.128.56.153', 'port': 38639, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'icibe_pro_proxy':{'host': '10.128.56.153', 'port': 39026, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'cdc_icibe_job_ro':{'host': '10.128.56.153', 'port': 39026, 'user': 'cdcjob_icibe', 'password': 'cnHjs$gV3DNernV4'},

    'tp_pro_write':{'host': '10.128.56.90', 'user': 'cdcapp_tp', 'port': 3310, 'password': 'D)$V0%4Dr0a&'},
    'tp_pro_support':{'host': '10.128.56.153', 'user': 'cdcapp_tp', 'port': 34276, 'password': 'D)$V0%4Dr0a&'}

}
adm_pro_cons={
    'drlt_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'drlv_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvb_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvn_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},

    'tps_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},
    'wtctr_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},

    'icibe_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'icibe_pro_dict': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'host': 'exa4-scan.uk.aswatson.net', 'port': 1521, 'service_name': 'CRMBKVP'},
    'icinl_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'}

}


# ------------------------------------------------------------------------------------------------------------------------------------------------------------


siebel_oracle_uat_cons={
    'icibe_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'},
    'icinl_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'}
}

siebel_oracle_pro_cons={
    'icibe_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'},
    'icinl_pro': {'user': 'DATAIN_USER', 'password': 'LostTrack#123', 'dsn': 'ukleds12.uk.aswatson.net:1521/UKSKVP'}
}

cdc_mysql_uat_cons = {
    'kvb_uat': {'host': '10.168.56.87', 'port': 3306, 'user': 'cdcapp_kvb', 'password': 'SGev6!r6hR0&E2mS'},
    'kvn_uat': {'host': '10.168.56.87', 'port': 3306, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'tps_uat': {'host': '10.168.56.86', 'port': 3306, 'user': 'cdcapp_tps', 'password': 'h5^4wVYKBpxTGDaz'},
    'wtctr_uat': {'host': '10.168.56.86', 'port': 3306, 'user': 'cdcapp_wtctr', 'password': 'h5^4wVYKBpxTGDaz'},
    'drlt_uat': {'host': '10.168.56.87', 'port': 3306, 'user': 'cdcapp_drlt', 'password': 'h5^4wVYKBpxTGDaz'},
    'drlv_uat': {'host': '10.168.56.87', 'port': 3306, 'user': 'cdcapp_drlv', 'password': 'h5^4wVYKBpxTGDaz'},
    'drlv_uat_config': {'host': '10.168.56.152', 'port': 36797, 'user': 'cdcapp_drlv', 'password': 'h5^4wVYKBpxTGDaz'},
    'icinl_uat': {'host': '10.168.56.87', 'port': 3306, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icibe_uat': {'host': '10.168.56.87', 'port': 3306, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'tp_uat': {'host': '10.168.56.87', 'port': 3306, 'user': 'cdcapp_tp', 'password': 'Change_m3!'}
}


cdc_mysql_pro_cons = {
    'kvb_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'kvb_pro_cal':{'host': '10.128.56.153', 'port': 33448, 'user': 'cdcapp_kvb', 'password': 'y^Ttl89m21pC94y2'},
    'kvb_pro_member':{'host': '10.128.56.153', 'port': 36008, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    # 'kvb_pro_proxy':{'host': '10.128.56.153', 'port': 31410, 'user': 'cdcapp_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'kvb_pro_proxy':{'host': '10.128.56.153', 'port': 31410, 'user': 'cdcjob_kvb', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_kvb_job_ro': {'host': '10.128.56.153', 'port': 31410, 'user': 'cdcjob_kvb', 'password': 'p438jUPYgI8SVD^t'},

    'kvn_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'kvn_pro_cal0_32':{'host': '10.128.56.153', 'port': 35272, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal33_36':{'host': '10.128.56.153', 'port': 38919, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal67_100':{'host': '10.128.56.153', 'port': 39944, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_cal101_127':{'host': '10.128.56.153', 'port': 33409, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    'kvn_pro_member':{'host': '10.128.56.153', 'port': 36534, 'user': 'cdcapp_kvn', 'password': 'h5^4wVYKBpxTGDaz'},
    # 'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 33726, 'user': 'cdcapp_kvn', 'password': 'p438jUPYgI8SVD^t'},
    # 'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 33726, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'kvn_pro_proxy':{'host': '10.128.56.153', 'port': 38017, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_kvn_job_ro': {'host': '10.128.56.153', 'port': 33726, 'user': 'cdcjob_kvn', 'password': 'p438jUPYgI8SVD^t'},

    'tps_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'tps_pro_cal':{'host': '10.128.56.153', 'port': 32257, 'user': 'cdcapp_tps', 'password': 'y^Ttl89m21pC94y2'},
    'tps_pro_member':{'host': '10.128.56.153', 'port': 39798, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'tps_pro_proxy':{'host': '10.128.56.153', 'port': 32244, 'user': 'cdcapp_tps', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_tps_job_ro': {'host': '10.128.56.153', 'port': 32244, 'user': 'cdcjob_tps', 'password': 'p438jUPYgI8SVD^t'},

    'wtctr_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal0_32':{'host': '10.128.56.153', 'port': 32331, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal33_36':{'host': '10.128.56.153', 'port': 34241, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal67_100':{'host': '10.128.56.153', 'port': 30423, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_cal101_127':{'host': '10.128.56.153', 'port': 30037, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_member':{'host': '10.128.56.153', 'port': 37860, 'user': 'cdcapp_wtctr', 'password': 'wzbFk*DYB4FiodI3'},
    'wtctr_pro_proxy':{'host': '10.128.56.153', 'port': 34703, 'user': 'cdcapp_wtctr', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_wtctr_job_ro': {'host': '10.128.56.153', 'port': 34703, 'user': 'cdcjob_wtctr','password': 'p438jUPYgI8SVD^t'},

    'drlt_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_drlt', 'password': 'p438jUPYgI8SVD^t'},
    'drlt_pro_cal':{'host': '10.128.56.153', 'port': 33400, 'user': 'cdcapp_drlt', 'password': 'jzZ2TOh^jGeNjEBj'},
    'drlt_pro_member':{'host': '10.128.56.153', 'port': 34368, 'user': 'cdcapp_drlt', 'password': 'jzZ2TOh^jGeNjEBj'},
    'drlt_pro_proxy':{'host': '10.128.56.153', 'port': 34110, 'user': 'cdcapp_drlt', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_drlt_job_ro': {'host': '10.128.56.153', 'port': 34110, 'user': 'cdcjob_drlt', 'password': 'p438jUPYgI8SVD^t'},

    'drlv_pro_job':{'host': '10.128.56.153', 'port': 37357, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_cal':{'host': '10.128.56.153', 'port': 32728, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_member':{'host': '10.128.56.153', 'port': 32195, 'user': 'cdcapp_drlv', 'password': 'o1QJ&TIS5PqhSx#p'},
    'drlv_pro_proxy':{'host': '10.128.56.153', 'port': 39320, 'user': 'cdcapp_drlv', 'password': 'p438jUPYgI8SVD^t'},
    'cdc_drlv_job_ro': {'host': '10.128.56.153', 'port': 39320, 'user': 'cdcjob_drlv', 'password': 'p438jUPYgI8SVD^t'},

    'icinl_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_cal':{'host': '10.128.56.153', 'port': 37993, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_member':{'host': '10.128.56.153', 'port': 39644, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'icinl_pro_proxy':{'host': '10.128.56.153', 'port': 34419, 'user': 'cdcapp_icinl', 'password': 'bg*m9cPJF37oMRus'},
    'cdc_icinl_job_ro': {'host': '10.128.56.153', 'port': 34419, 'user': 'cdcjob_icinl','password': 'bg*m9cPJF37oMRus'},

    'icibe_pro_job':{'host': '10.128.56.153', 'port': 34843, 'user': 'cdcapp_icibe', 'password': 'xMm$jRPY$L2CJ0N5'},
    'icibe_pro_cal':{'host': '10.128.56.153', 'port': 38720, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'icibe_pro_member':{'host': '10.128.56.153', 'port': 38639, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'icibe_pro_proxy':{'host': '10.128.56.153', 'port': 39026, 'user': 'cdcapp_icibe', 'password': 'cnHjs$gV3DNernV4'},
    'cdc_icibe_job_ro':{'host': '10.128.56.153', 'port': 39026, 'user': 'cdcjob_icibe', 'password': 'cnHjs$gV3DNernV4'},

    'tp_pro_write':{'host': '10.128.56.90', 'user': 'cdcapp_tp', 'port': 3310, 'password': 'D)$V0%4Dr0a&'},
    'tp_pro_support':{'host': '10.128.56.153', 'user': 'cdcapp_tp', 'port': 34276, 'password': 'D)$V0%4Dr0a&'}

}

adm_oracle_uat_cons={
    'drlt_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'drlv_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvb_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvn_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},

    'tps_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},
    'wtctr_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},

    'icibe_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'icibe_pro_dict': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'host': 'exa4-scan.uk.aswatson.net', 'port': 1521, 'service_name': 'CRMBKVP'},
    'icinl_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'}

}

adm_oracle_pro_cons={
    'drlt_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'drlv_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvb_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'kvn_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},

    'tps_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},
    'wtctr_pro': {'user': 'CRM_CDC', 'password': 'crm_cdc', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBSDP'},

    'icibe_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'},
    'icibe_pro_dict': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'host': 'exa4-scan.uk.aswatson.net', 'port': 1521, 'service_name': 'CRMBKVP'},
    'icinl_pro': {'user': 'CRM_CDC_PP', 'password': 'xDzkcrmIM3cdcV4ppy', 'dsn': 'exa4-scan.uk.aswatson.net:1521/CRMBKVP'}

}

sftp_uat_cons = {
    'icibe_uat': {'ip': 'aswextftp01.uk.aswatson.net', 'port': '22', 'ftpPath': '/upload/cdc/UAT/Legal_Masking/outbox', 'userName': 'UATGITCDCSFTP01', 'pwd': 'UATcdc$ftp'},
    'icinl_uat': {'ip': 'aswextftp01.uk.aswatson.net', 'port': '22', 'ftpPath': '/upload/cdc/UAT/Legal_Masking/outbox', 'userName': 'UATGITCDCSFTP01', 'pwd': 'UATcdc$ftp'}
}

sftp_pro_cons = {
    'icibe_uat': {'ip': 'aswextftp01.uk.aswatson.net', 'port': '22', 'ftpPath': '/upload/cdc/UAT/Legal_Masking/outbox', 'userName': 'UATGITCDCSFTP01', 'pwd': 'UATcdc$ftp'},
    'icinl_uat': {'ip': 'aswextftp01.uk.aswatson.net', 'port': '22', 'ftpPath': '/upload/cdc/UAT/Legal_Masking/outbox', 'userName': 'UATGITCDCSFTP01', 'pwd': 'UATcdc$ftp'}
}

minio_uat_cons = {
    'endpoint': 'http://10.168.56.47:9000', 'authentication': {'accesskey': 'minio', 'secretkey': 'QAZ2wsxed!'}
}

minio_pro_cons = {
    'endpoint': 'http://10.168.56.47:9000', 'authentication': {'accesskey': 'minio', 'secretkey': 'QAZ2wsxed!'}
}

# ------------------------------------------------------------------------------------------------------------------------------------------------------------


# print(cdc_mysql_uat_cons)
